Stored Procedures [dbo].[BAECartEventInsert]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@CartItemIDint4
@EventCodevarchar(64)64
@Titlevarchar(128)128
@RegistrantClassvarchar(64)64
@RegistrantIDvarchar(16)16
@Completebit1
SQL Script
create procedure [dbo].[BAECartEventInsert] @CartItemID as
int,    
    @EventCode AS varchar(64),    
    @Title AS varchar(128),    
    @RegistrantClass AS varchar(64),    
    @RegistrantID AS varchar(16),    
    @Complete AS bit
AS
    INSERT INTO CartEvent
    (CartItemID,
    EventCode,
    Title,
    RegistrantClass,
    RegistrantID,
    Complete)
    VALUES
    (@CartItemID,
    @EventCode,
    @Title,
    @RegistrantClass,
    @RegistrantID,
    @Complete);
    
SELECT CAST(@@IDENTITY AS int) AS 'InsertedCartEvent';

GO
Uses